Categories

Versions

You are viewing the RapidMiner Studio documentation for version 10.1 - Check here for latest version

Get Excel Sheet Names (Operator Toolbox)

Synopsis

This operator takes an Excel file and returns the list of sheets which are in this file.

Description

A file can either be provided as a path or as a file object on the input port. The result is an ExampleSet with two attributes: Sheet Number and Sheet Name.

Input

  • fil (File)

    The excel file which should be used. This is not mandatory. File objects can be generated with operators like Open File or Loop Files.

Output

  • exa (Data Table)

    The ExampleSet with the sheet names and numbers.

Parameters

  • file_nameThe path to the Excel file. Range: configurable

Tutorial Processes

Read Sheet Names

In this example we generate an excel file and extract the sheet names of this generated file again using the file input port.